/**
 * 
 */
package com.orange.handler.expert;

import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import com.orange.dbhelp.page.Page;
import com.orange.modules.bean.SchoolItemBean;
import com.orange.modules.entity.AuthItem;
import com.orange.modules.entity.expert.AuthExpertItemMap;
import com.orange.modules.entity.expert.AuthExpertSchoolMap;

/**
 * @author gaogs
 *
 * 2016-12-15
 */
public interface AuthExpertSchoolMapService {
	
	/**
	 * 材料评审——保存专家与学校的关系
	 * @param list
	 */
	public void saveAuthExpertSchoolMapList(List<AuthExpertSchoolMap>list);
	
	/**
	 * 材料评审——根据专家id删除专家与学校的关系
	 * @param pid
	 * @throws SQLException 
	 */
	public void deleteAuthExpertSchoolMapInfo(String expertId) throws SQLException;
	
	/**
	 * 根据专家id查询专家绑定的学校
	 * @param expertId
	 * @return
	 * @throws SQLException
	 */
	public List<AuthExpertSchoolMap> queryAuthExpertSchoolMapInfoByExpert(String expertId) throws SQLException;

	/**
	 * 分页查询材料评审专家绑定的学校
	 * 
	 */
	public Page<SchoolItemBean> queryAuthSchoolPageByExportId(String exportId ,Map<String, String> map) throws SQLException;
	
	/**
	 * 根据专家id查询专家绑定的学校
	 * @param expertId
	 * @return
	 * @throws SQLException
	 */
	public AuthExpertSchoolMap queryAuthExpertSchoolMapInfoByExpert1(String expertId) throws SQLException;
	
	/**
	 * 查看一级指标材料评审分项意见记录表中的学校对应的指标
	 * @throws SQLException 
	 */
	public List<AuthItem> queryAuthItemBySchoolIdAndExpertId(String schoolId, String expertId) throws SQLException;
	
	/**
	 * 分页查询材料评审专家绑定的学校
	 * 
	 */
	public Page<SchoolItemBean> queryAuthSchoolPageByGroupId(String expertId ,Map<String, String> map) throws SQLException;
	
	/**
	 * 根据组id查询学校id
	 * @throws SQLException 
	 */
	public List<AuthExpertSchoolMap> querySchoolIdByGroupId(String groupId) throws SQLException;
	
	/**
	 * 分页查询材料评审专家绑定的学校
	 * 
	 */
	public Page<SchoolItemBean> queryAuthSchoolPageByGroupId1(String groupId ,Map<String, String> map) throws SQLException;

}
